[dbo].[BAEImisIsoCurrencyCodesGetAllWithExchangeRate]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisIsoCurrencyCodesGetAllWithExchangeRate

Property	Value
ANSI Nulls On
Quoted Identifier On

CREATE PROCEDURE [dbo].[BAEImisIsoCurrencyCodesGetAllWithExchangeRate]
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT * from Iso_Currency_Codes where CurrencyCode IN (Select CurrencyCode from Exchange_Rate)
END

GO